package com.sky.service.impl;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.sky.constant.MessageConstant;
import com.sky.constant.StatusConstant;
import com.sky.dto.SetmealDTO;
import com.sky.dto.SetmealPageQueryDTO;
import com.sky.entity.Dish;
import com.sky.entity.Setmeal;
import com.sky.entity.SetmealDish;
import com.sky.exception.DeletionNotAllowedException;
import com.sky.exception.SetmealEnableFailedException;
import com.sky.mapper.DishMapper;
import com.sky.mapper.SetmealDishMapper;
import com.sky.mapper.SetmealMapper;
import com.sky.result.PageResult;
import com.sky.service.SetmealService;
import com.sky.vo.DishItemVO;
import com.sky.vo.SetmealVO;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**
 * 套餐业务实现
 */
@Service
@Slf4j
public class SetmealServiceImpl implements SetmealService {
  @Autowired
  private SetmealMapper setmealMapper;
  @Autowired
  private SetmealDishMapper setmealDishMapper;
  @Autowired
  private DishMapper dishMapper;

  /**
   * 新增套餐，同时需要保存套餐和菜品的关联关系
   * @param setmealDTO
   */
  @Transactional
  public void saveWithDish(SetmealDTO setmealDTO) {
    Setmeal setmeal = new Setmeal();
    BeanUtils.copyProperties(setmealDTO, setmeal);

    //向套餐表插入数据
    setmealMapper.insert(setmeal);

    //获取生成的套餐id
    Long setmealId = setmeal.getId();

    List<SetmealDish> setmealDishes = setmealDTO.getSetmealDishes();
    setmealDishes.forEach(setmealDish -> {
      setmealDish.setSetmealId(setmealId);
    });

    //保存套餐和菜品的关联关系
    setmealDishMapper.insertBatch(setmealDishes);
  }

  /**
   * 分页查询
   * @param setmealPageQueryDTO
   * @return
   */
  public PageResult pageQuery(SetmealPageQueryDTO setmealPageQueryDTO) {
    int pageNum = setmealPageQueryDTO.getPage();
    int pageSize = setmealPageQueryDTO.getPageSize();

    PageHelper.startPage(pageNum, pageSize);
    Page<SetmealVO> page = setmealMapper.pageQuery(setmealPageQueryDTO);
    return new PageResult(page.getTotal(), page.getResult());
  }

  /**
   * 批量删除套餐
   * @param ids
   */
  @Transactional
  public void deleteBatch(List<Long> ids) {
    ids.forEach(id -> {
      Setmeal setmeal = setmealMapper.getById(id);
      if (StatusConstant.ENABLE == setmeal.getStatus()) {
        //起售中的套餐不能删除
        throw new DeletionNotAllowedException(MessageConstant.SETMEAL_ON_SALE);
      }
    });

    ids.forEach(setmealId -> {
      //删除套餐表中的数据
      setmealMapper.deleteById(setmealId);
      //删除套餐菜品关系表中的数据
      setmealDishMapper.deleteBySetmealId(setmealId);
    });
  }

  /**
   * 根据id查询套餐和套餐菜品关系
   * @param id
   * @return
   */
  public SetmealVO getByIdWithDish(Long id) {
    SetmealVO setmealVO = setmealMapper.getByIdWithDish(id);
    return setmealVO;
  }

  /**
   * 修改套餐
   * @param setmealDTO
   */
  @Transactional
  public void update(SetmealDTO setmealDTO) {
    Setmeal setmeal = new Setmeal();
    BeanUtils.copyProperties(setmealDTO, setmeal);

    //1、修改套餐表，执行update
    setmealMapper.update(setmeal);

    //套餐id
    Long setmealId = setmealDTO.getId();

    //2、删除套餐和菜品的关联关系，操作setmeal_dish表，执行delete
    setmealDishMapper.deleteBySetmealId(setmealId);

    List<SetmealDish> setmealDishes = setmealDTO.getSetmealDishes();
    setmealDishes.forEach(setmealDish -> {
      setmealDish.setSetmealId(setmealId);
    });
    //3、重新插入套餐和菜品的关联关系，操作setmeal_dish表，执行insert
    setmealDishMapper.insertBatch(setmealDishes);
  }

  /**
   * 套餐起售、停售
   * @param status
   * @param id
   */
  public void startOrStop(Integer status, Long id) {
    //起售套餐时，判断套餐内是否有停售菜品，有停售菜品提示"套餐内包含未启售菜品，无法启售"
    if (status == StatusConstant.ENABLE) {
      //select a.* from dish a left join setmeal_dish b on a.id = b.dish_id where b.setmeal_id = ?
      List<Dish> dishList = dishMapper.getBySetmealId(id);
      if (dishList != null && dishList.size() > 0) {
        dishList.forEach(dish -> {
          if (StatusConstant.DISABLE == dish.getStatus()) {
            throw new SetmealEnableFailedException(MessageConstant.SETMEAL_ENABLE_FAILED);
          }
        });
      }
    }

    Setmeal setmeal = Setmeal.builder()
      .id(id)
      .status(status)
      .build();
    setmealMapper.update(setmeal);
  }

  /**
   * 条件查询
   * @param setmeal
   * @return
   */
  public List<Setmeal> list(Setmeal setmeal) {
    List<Setmeal> list = setmealMapper.list(setmeal);
    return list;
  }

  /**
   * 根据id查询菜品选项
   * @param id
   * @return
   */
  public List<DishItemVO> getDishItemById(Long id) {
    return setmealMapper.getDishItemBySetmealId(id);
  }
}
